---
title: "SQL-184 to SQL-205: Delete operations"
summary: Delete operations across this library — stored-procedure deletes and inline DELETE statements.
status: draft
owner: SAIF Documentation Generator
last_reviewed: 2026-08-21
library: SAIF.Business.Claim.Legal
reference_type: embedded
---

# SQL-184 to SQL-205: Delete operations

This page documents all 22 Delete-type SQL operations (SQL-184 through SQL-205). Stored-procedure deletes have their body retrieval marked unavailable for this run (Legends CLI offline); see [Procedures](../procedures/index.md).

## SQL-184 clsAppeal

`clsAppeal` — stored procedure call against `pk80001_legalnet.DeleteAppeal`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-184 |
| **Operation type** | Delete |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsAppeal` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.DeleteAppeal(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsAppeal.vb`

---
## SQL-185 clsAttorneyConflict.Criteria.DeleteSQL

`clsAttorneyConflict.Criteria.DeleteSQL` — inline DELETE against `ATTORNEY_CONFLICT`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-185 |
| **Operation type** | Delete |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsAttorneyConflict` |
| **Criteria property** | `DeleteSQL` |
| **Lifecycle method** | `BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [ATTORNEY_CONFLICT](../database-tables.md#attorney_conflict) | DELETE | See Sample SQL below |

### Sample SQL

```sql
-- Delete against ATTORNEY_CONFLICT
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Delete statements against ATTORNEY_CONFLICT in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneyConflict.vb`

---
## SQL-186 clsAttorneyPolicyAssignment.Criteria.DeleteSQL

`clsAttorneyPolicyAssignment.Criteria.DeleteSQL` — inline DELETE against `ATTORNEY_POLICY_ASSIGNMENT`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-186 |
| **Operation type** | Delete |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsAttorneyPolicyAssignment` |
| **Criteria property** | `DeleteSQL` |
| **Lifecycle method** | `BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [ATTORNEY_POLICY_ASSIGNMENT](../database-tables.md#attorney_policy_assignment) | DELETE | See Sample SQL below |

### Sample SQL

```sql
-- Delete against ATTORNEY_POLICY_ASSIGNMENT
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Delete statements against ATTORNEY_POLICY_ASSIGNMENT in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneyPolicyAssignment.vb`

---
## SQL-187 clsAttorneySchedule.Criteria.DeleteSQL

`clsAttorneySchedule.Criteria.DeleteSQL` — inline DELETE against `ATTORNEY_SCHEDULE`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-187 |
| **Operation type** | Delete |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsAttorneySchedule` |
| **Criteria property** | `DeleteSQL` |
| **Lifecycle method** | `BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [ATTORNEY_SCHEDULE](../database-tables.md#attorney_schedule) | DELETE | See Sample SQL below |

### Sample SQL

```sql
-- Delete against ATTORNEY_SCHEDULE
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Delete statements against ATTORNEY_SCHEDULE in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneySchedule.vb`

---
## SQL-188 clsAttorneyWorkerAssignment.Criteria.DeleteSQL

`clsAttorneyWorkerAssignment.Criteria.DeleteSQL` — inline DELETE against `ATTORNEY_WORKER_ASSIGNMENT`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-188 |
| **Operation type** | Delete |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsAttorneyWorkerAssignment` |
| **Criteria property** | `DeleteSQL` |
| **Lifecycle method** | `BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [ATTORNEY_WORKER_ASSIGNMENT](../database-tables.md#attorney_worker_assignment) | DELETE | See Sample SQL below |

### Sample SQL

```sql
-- Delete against ATTORNEY_WORKER_ASSIGNMENT
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Delete statements against ATTORNEY_WORKER_ASSIGNMENT in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneyWorkerAssignment.vb`

---
## SQL-189 clsCaseCost.Criteria.DeleteSQL

`clsCaseCost.Criteria.DeleteSQL` — inline DELETE against `CASE_COST`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-189 |
| **Operation type** | Delete |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsCaseCost` |
| **Criteria property** | `DeleteSQL` |
| **Lifecycle method** | `BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [CASE_COST](../database-tables.md#case_cost) | DELETE | See Sample SQL below |

### Sample SQL

```sql
-- Delete against CASE_COST
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Delete statements against CASE_COST in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsCaseCost.vb`

---
## SQL-190 clsCaseNote

`clsCaseNote` — stored procedure call against `pk80001_legalnet.case_note_delete`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-190 |
| **Operation type** | Delete |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsCaseNote` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.case_note_delete(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsCaseNote.vb`

---
## SQL-191 clsCaseOutcome

`clsCaseOutcome` — stored procedure call against `pk80001_legalnet.DeleteCaseOutcome`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-191 |
| **Operation type** | Delete |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsCaseOutcome` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.DeleteCaseOutcome(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsCaseOutcome.vb`

---
## SQL-192 clsCaseStatusHistory.Criteria.DeleteSQL

`clsCaseStatusHistory.Criteria.DeleteSQL` — inline DELETE against `CASE_STATUS_HISTORY`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-192 |
| **Operation type** | Delete |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsCaseStatusHistory` |
| **Criteria property** | `DeleteSQL` |
| **Lifecycle method** | `BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [CASE_STATUS_HISTORY](../database-tables.md#case_status_history) | DELETE | See Sample SQL below |

### Sample SQL

```sql
-- Delete against CASE_STATUS_HISTORY
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Delete statements against CASE_STATUS_HISTORY in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsCaseStatusHistory.vb`

---
## SQL-193 clsHearingLocation.Criteria.DeleteSQL

`clsHearingLocation.Criteria.DeleteSQL` — inline DELETE against `HEARING_LOCATION`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-193 |
| **Operation type** | Delete |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsHearingLocation` |
| **Criteria property** | `DeleteSQL` |
| **Lifecycle method** | `BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [HEARING_LOCATION](../database-tables.md#hearing_location) | DELETE | See Sample SQL below |

### Sample SQL

```sql
-- Delete against HEARING_LOCATION
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Delete statements against HEARING_LOCATION in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsHearingLocation.vb`

---
## SQL-194 clsHearingLocationInfo.Criteria.DeleteSQL

`clsHearingLocationInfo.Criteria.DeleteSQL` — inline DELETE against `HEARING_LOCATION`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-194 |
| **Operation type** | Delete |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsHearingLocationInfo` |
| **Criteria property** | `DeleteSQL` |
| **Lifecycle method** | `BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [HEARING_LOCATION](../database-tables.md#hearing_location) | DELETE | See Sample SQL below |

### Sample SQL

```sql
-- Delete against HEARING_LOCATION
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Delete statements against HEARING_LOCATION in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsHearingLocationInfo.vb`

---
## SQL-195 clsLegalCase

`clsLegalCase` — stored procedure call against `pk80001_legalnet.DeleteLegalCase`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-195 |
| **Operation type** | Delete |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsLegalCase` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.DeleteLegalCase(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsLegalCase.vb`

---
## SQL-196 clsLegalCaseEmployer.Criteria.DeleteSQL

`clsLegalCaseEmployer.Criteria.DeleteSQL` — inline DELETE against `LEGAL_CASE_EMPLOYER`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-196 |
| **Operation type** | Delete |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsLegalCaseEmployer` |
| **Criteria property** | `DeleteSQL` |
| **Lifecycle method** | `BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [LEGAL_CASE_EMPLOYER](../database-tables.md#legal_case_employer) | DELETE | See Sample SQL below |

### Sample SQL

```sql
-- Delete against LEGAL_CASE_EMPLOYER
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Delete statements against LEGAL_CASE_EMPLOYER in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsLegalCaseEmployer.vb`

---
## SQL-197 clsLegalFileLocation

`clsLegalFileLocation` — inline DELETE against `LEGAL_FILE_LOCATION`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-197 |
| **Operation type** | Delete |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsLegalFileLocation` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [LEGAL_FILE_LOCATION](../database-tables.md#legal_file_location) | DELETE | See Sample SQL below |

### Sample SQL

```sql
-- Delete against LEGAL_FILE_LOCATION
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Delete statements against LEGAL_FILE_LOCATION in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsLegalFileLocation.vb`

---
## SQL-198 clsLegalPerson.Criteria.DeleteSQL

`clsLegalPerson.Criteria.DeleteSQL` — inline DELETE against `LEGAL_PERSON`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-198 |
| **Operation type** | Delete |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsLegalPerson` |
| **Criteria property** | `DeleteSQL` |
| **Lifecycle method** | `BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [LEGAL_PERSON](../database-tables.md#legal_person) | DELETE | See Sample SQL below |

### Sample SQL

```sql
-- Delete against LEGAL_PERSON
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Delete statements against LEGAL_PERSON in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsLegalPerson.vb`

---
## SQL-199 clsLegalPersonType.Criteria.DeleteSQL

`clsLegalPersonType.Criteria.DeleteSQL` — inline DELETE against `LEGAL_PERSON_TYPE`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-199 |
| **Operation type** | Delete |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsLegalPersonType` |
| **Criteria property** | `DeleteSQL` |
| **Lifecycle method** | `BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [LEGAL_PERSON_TYPE](../database-tables.md#legal_person_type) | DELETE | See Sample SQL below |

### Sample SQL

```sql
-- Delete against LEGAL_PERSON_TYPE
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Delete statements against LEGAL_PERSON_TYPE in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsLegalPersonType.vb`

---
## SQL-200 clsLegalSchedule.deleteSchedule

`clsLegalSchedule.deleteSchedule` — stored procedure call against `pk80001_legalnet.deleteSchedule`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-200 |
| **Operation type** | Delete |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsLegalSchedule` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.deleteSchedule(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsLegalSchedule.vb`

---
## SQL-201 clsOtherFirm.Criteria.DeleteSQL

`clsOtherFirm.Criteria.DeleteSQL` — inline DELETE against `OTHER_FIRM`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-201 |
| **Operation type** | Delete |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsOtherFirm` |
| **Criteria property** | `DeleteSQL` |
| **Lifecycle method** | `BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [OTHER_FIRM](../database-tables.md#other_firm) | DELETE | See Sample SQL below |

### Sample SQL

```sql
-- Delete against OTHER_FIRM
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Delete statements against OTHER_FIRM in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsOtherFirm.vb`

---
## SQL-202 clsOtherLegalParty.Criteria.DeleteSQL

`clsOtherLegalParty.Criteria.DeleteSQL` — inline DELETE against `LEGAL_CASE_EMPLOYER`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-202 |
| **Operation type** | Delete |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsOtherLegalParty` |
| **Criteria property** | `DeleteSQL` |
| **Lifecycle method** | `BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [LEGAL_CASE_EMPLOYER](../database-tables.md#legal_case_employer) | DELETE | See Sample SQL below |

### Sample SQL

```sql
-- Delete against LEGAL_CASE_EMPLOYER
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Delete statements against LEGAL_CASE_EMPLOYER in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsOtherLegalParty.vb`

---
## SQL-203 clsOutcomeIssue.Criteria.DeleteSQL

`clsOutcomeIssue.Criteria.DeleteSQL` — inline DELETE against `OUTCOME_ISSUE`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-203 |
| **Operation type** | Delete |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsOutcomeIssue` |
| **Criteria property** | `DeleteSQL` |
| **Lifecycle method** | `BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [OUTCOME_ISSUE](../database-tables.md#outcome_issue) | DELETE | See Sample SQL below |

### Sample SQL

```sql
-- Delete against OUTCOME_ISSUE
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Delete statements against OUTCOME_ISSUE in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsOutcomeIssue.vb`

---
## SQL-204 clsOutcomeStaff.Criteria.DeleteSQL

`clsOutcomeStaff.Criteria.DeleteSQL` — inline DELETE against `OUTCOME_STAFF`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-204 |
| **Operation type** | Delete |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsOutcomeStaff` |
| **Criteria property** | `DeleteSQL` |
| **Lifecycle method** | `BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [OUTCOME_STAFF](../database-tables.md#outcome_staff) | DELETE | See Sample SQL below |

### Sample SQL

```sql
-- Delete against OUTCOME_STAFF
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Delete statements against OUTCOME_STAFF in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsOutcomeStaff.vb`

---
## SQL-205 clsOutOFTownRotationAssgn.Criteria.DeleteSQL + clsRequestIssue.Criteria.DeleteSQL

`clsOutOFTownRotationAssgn.Criteria.DeleteSQL + clsRequestIssue.Criteria.DeleteSQL` — inline DELETE against `OUT_OF_TOWN_ROTATION_ASSGN, REQUEST_ISSUE`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-205 |
| **Operation type** | Delete |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsOutOFTownRotationAssgn` |
| **Criteria property** | `DeleteSQL` |
| **Lifecycle method** | `BeforeDelete` / `AfterDelete` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [OUT_OF_TOWN_ROTATION_ASSGN](../database-tables.md#out_of_town_rotation_assgn) | DELETE | See Sample SQL below |

### Sample SQL

```sql
-- Delete against OUT_OF_TOWN_ROTATION_ASSGN, REQUEST_ISSUE
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Delete statements against OUT_OF_TOWN_ROTATION_ASSGN, REQUEST_ISSUE in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsOutOFTownRotationAssgn.vb, LegalNet\clsRequestIssue.vb`

---
## Related documentation
- [Index](../index.md)
- [Overview](../overview.md)
- [Architecture](../architecture.md)
- [Dependencies](../dependencies.md)
- [Operations and processes](../operations-processes.md)
- [Business rules](../business-rules.md)
- [Database tables](../database-tables.md)
- [SQL catalog](index.md)
- [API reference](../api/index.md)

> **Note:** Statements marked with `*` were inferred from code structure, naming
> conventions, or contextual evidence where direct confirmation was not available
> in source artifacts. Statements marked with `**` could not be confirmed; treat
> as unknown until verified.

## Sources
- See per-SQL-ID Sources subsections above for exact .vb file/line citations.